package com.ruoyi.system.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DataMapper {
    /**
     * 查询用户数量
     */
    @Select("SELECT COUNT(*) FROM sys_user")
    long selectUserCount();
    /**
     * 查询订单数量
     */
    @Select("SELECT COUNT(*) FROM order_history")
    long selectHotelBookCount();
    /**
     * 查询酒店数量
     */
    @Select("SELECT COUNT(*) FROM hotel")
    long selectHotelCount();

    /**
     * 查询景点数量
     */
    @Select("SELECT COUNT(*) FROM scenicarea")
    long selectScenicareaCount();
}
